<%--
 *  File:    UploadSummaryOrganizationGrade.jsp
 *  @Author: DC
 *  Date:    2012/9/19
 *
 *  Copyright (C) 2000 - 2008 Oval Technologies, Inc.
 *  All rights reserved. 
 *
 *  This software is the confidential and proprietary information of Oval 
 *  Technologies, Inc. ("Confidential Information").  You shall not
 *  disclose such Confidential Information and shall use it only in
 *  accordance with the terms of the license agreement you entered into
 *  with Oval.
--%>

<%@ page contentType = "text/html;charset=UTF-8" %>
<%@ taglib uri="/WEB-INF/PageFlow.tld" prefix="PageFlow" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/oval-tag.tld" prefix="oval" %>
<%@ taglib uri="/WEB-INF/custom.tld" prefix="custom" %>

<%
  //init param
  String privilegeCode = "11406";
  String strTableName = "";
  String strModuleName = "PCM";
  String contextPath = request.getContextPath();
%>
<%@ include file="/inc/CommonHeader.inc" %>
<%@ include file="/inc/OvalLocationDefault.inc" %>
<%@ include file="/rpt/ReportURL.inc"%>

<html>
<head>
<title>UploadSummaryOrganizationGrade</title>
<PageFlow:CheckPageFlow pageName="p_temporggrade"/>
<%@ include file="/inc/CatchError.inc" %>
<%@ include file="/inc/SumDiv.inc" %>
<%
  Vector totalsummary = (Vector)pageContext.getAttribute("totalsummary");
  if(totalsummary == null) totalsummary = new Vector();

  HashMap UserInfo = (HashMap)session.getAttribute("userinfo");
  if(UserInfo == null) UserInfo = new HashMap();

  Integer datacategory = (Integer)pageContext.getAttribute("datacategory");
  String flag = "";
  Vector provector = (Vector)pageContext.getAttribute("provector");
  if(datacategory.intValue()==112){
    flag = "orggrade";
  }else if(datacategory.intValue()==113){
    flag = "hospitalgrade";
  }else if(datacategory.intValue()==114){
    flag = "pharmacygrade";
  }
  
  HashMap prohash=new HashMap();
  for(int i=0;i<provector.size();i++){
	  prohash.put(((HashMap)provector.get(i)).get("numcode"),((HashMap)provector.get(i)).get("productgroupname"));
  }

%>
<link rel="stylesheet" href="<%=contextPath%>/css/<%= strLanguageCode %>/main.css" type="text/css">
<script language="JavaScript" src="<%=contextPath%>/css/cn/script.js"></script>
<script language="JavaScript" src="<%=contextPath%>/js/ScriptLib.js"></script>
<script language="JavaScript" src="<%=contextPath%>/js/SummaryDivision.js"></script>

<script language="JavaScript">
<%--  put your custom script here   --%>
function page_summary(actionvalue,orderbyname)
{
  var editform = summaryPrepare(cform,actionvalue,orderbyname);
  if(!editform) return;
  editform.action = "UploadSummaryOrganizationGrade.jsp?<%= OvalTools.randomURL() %>";
  editform.target = "_self";
  isRunning = true;
  editform.submit();
}

function page_check()
{
    cform.actionname.value = "check";
    cform.target = "_self";
    isRunning = true;
    cform.submit();
}

function page_confirm(){
	cform.actionname.value = "confirm";
    cform.target = "_self";
    isRunning = true;
    cform.submit();
}

function page_giveup(){
	var flag1 = confirm("<%= message.getMessageDesc("SURE_GIVE_UP")%>");
	if(!flag1){
		return;
	}
	cform.actionname.value = "giveup";
    cform.target = "_self";
    isRunning = true;
    cform.submit();
}	

function page_operate(operand)
{  
	if(cform.filename.value === "" || cform.filename.value === null){
		return false;
	}
		  if (operand=="upload")
		  {
		    cform.encoding="multipart/form-data";
		    cform.actionname.value = "upload";
		    cform.target = "_self";
		    cform.submit();
		  }
	  
}
function page_print(){
	var cform = document.cform;
	cform.type.value = 'xlsdata';
	cform.name.value = 'distributorUploadInformation';
	
	cform.action="<%=contextPath%>/reportDirector";
	cform.target="_blank";
	cform.submit();
	cform.action="<%=contextPath%>/Dispatcher";	
}


function page_print(){
	  //preview
    <%
    if(new Integer(112).equals(datacategory)){ %>
       var url1 = "<%=reportURL%>/servlet/ExcecuteReport/temp_uploadorggradeerror.sox?__format=xlsx&__folder=/ovalreport&employeeid="+document.cform.userid.value;
      <%  }else if(new Integer(113).equals(datacategory)){    %>
        var url1 = "<%=reportURL%>/servlet/ExcecuteReport/temp_uploadhosgradeerror.sox?__format=xlsx&__folder=/ovalreport&employeeid="+document.cform.userid.value;
    <%    }else if(new Integer(114).equals(datacategory)){  %>
         var url1 = "<%=reportURL%>/servlet/ExcecuteReport/temp_uploadphgradeerror.sox?__format=xlsx&__folder=/ovalreport&employeeid="+document.cform.userid.value;
     <%   }
    %>

	//var strstatus="height=768, width=1024,top=0,left=0,toolbar=no, menubar=no, scrollbars=yes, resizable=yes, location=no, status=no";
    //popwindow = window.open(url1, "n1window", strstatus);
    DataReport(url1);
}

function page_confirm1(){
	 /*   if(nullChecked(document.cform.uploadorgids))
	        {
	          alert("<%= message.getMessageDesc("PLEASE_SELECT") %>");
	          return;
	        }*/
		cform.actionname.value = "confirm1";
	    cform.target = "_self";
	    isRunning = true;
	    cform.submit();
	}



</script>
</head>

<body style="overflow: auto;">
<form name="cform" method="post" action="<%=contextPath%>/Dispatcher">
    <input type="hidden" name="pagename" value="p_temporggrade">
    <input type="hidden" name="actionname">
    <input type="hidden" name="name">
    <input type="hidden" name="type">
    <input type="hidden" name="sheetname" value="gradeinfo">
    <input type="hidden" name="begioncolumn" value="5">
    <input type="hidden" name="endcolumn" value="43">
    <input type="hidden" name="standardnum" value="2">
    <input type="hidden" name="codeinsheet" value = "Y"/>

    <input type="hidden" name="flag" value="<%=flag %>">

    <input type="hidden" name="datacategory" value="<%=datacategory %>" />
    <input type="hidden" name="userid" value="<%= (Integer)UserInfo.get("userid") %>">
    <input type="hidden"
	name="__header__Content-disposition" id="outname"
	value="attachment;filename=DistributorMasterData.xls" />

<%--  page location   --%>
    <%@ include file="/inc/PageLocation.inc" %>

    <table width="100%" cellspacing="0" border="0" cellpadding="0">
      <tr>
<%--  search criteria  --%>
      </tr>
      <tr>
        <td>
          <table width="100%" border="0" cellspacing="0">
             <tr>
			  <td> 
			  	<%= label.getLabelName("L_Path") %><%= label.getLabelName("L_Colon") %><input type="file" name="filename" size="30" >
			    &nbsp;&nbsp;&nbsp;&nbsp;<a onclick="page_operate('upload')"><custom:button type="1" label="L_Finish" imgsrc="finish.gif" border="0" style="width:60"/></a>
			    
			  </td>
			 </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td>
<div style="overflow:auto;width:1130;height:400">
          <table width="6500"  border="1" cellpadding="0" bordercolorlight="#999999" bordercolordark="#FFFFFF" cellspacing="0" align="center">
            <tr class="deepblue-left">
              <td class="title_center" rowspan="2" width="1%"><%= label.getLabelName("L_RegionName") %></td>
              <td class="title_center" rowspan="2" width="1%"><%= label.getLabelName("L_CityName") %></td>
              <td class="title_center" rowspan="2" width="1%"><%= label.getLabelName("L_OrgCode") %></td>
              <td class="title_center" rowspan="2" width="1%"><%= label.getLabelName("L_OrgName") %></td>
              <td class="title_center" rowspan="2" width="1%"><%= label.getLabelName("L_Status") %></td>
			  
			  	<td class="title_center" colspan="2"><%=prohash.get("productgroupid1")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+1 : prohash.get("productgroupid1")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid2")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+2 : prohash.get("productgroupid2")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid3")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+3 : prohash.get("productgroupid3")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid4")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+4 : prohash.get("productgroupid4")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid5")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+5 : prohash.get("productgroupid5")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid6")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+6 : prohash.get("productgroupid6")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid7")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+7 : prohash.get("productgroupid7")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid8")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+8 : prohash.get("productgroupid8")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid9")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+9 : prohash.get("productgroupid9")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid10")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+10 : prohash.get("productgroupid10")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid11")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+11 : prohash.get("productgroupid11")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid12")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+12 : prohash.get("productgroupid12")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid13")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+13 : prohash.get("productgroupid13")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid14")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+14 : prohash.get("productgroupid14")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid15")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+15 : prohash.get("productgroupid15")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid16")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+16 : prohash.get("productgroupid16")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid17")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+17 : prohash.get("productgroupid17")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid18")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+18 : prohash.get("productgroupid18")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid19")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+19 : prohash.get("productgroupid19")%>&nbsp;</td>
                <td class="title_center" colspan="2"><%=prohash.get("productgroupid20")== null ? label.getLabelName("L_Product")+label.getLabelName("L_GroupNo")+20 : prohash.get("productgroupid20")%>&nbsp;</td>
         
              
              <td class="title_center" rowspan="2" width="2%"><%= label.getLabelName("L_ErrorMsg") %> </td>
            </tr>
            <tr class="deepblue-left">
              <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_level") %></td>
			  <td class="title_center" width="1%"><%= label.getLabelName("L_IsLocked") %></td>
            </tr>
<%
	int i=0;
	String strClassType="";
	String checkflag = null;
%>
            <%--  the old detail lines  --%>
 <span id="olddetail" >
            <logic:iterate id="onerow" collection="<%= totalsummary %>" indexId="idx" scope="page">
<%
	if(i%2 == 1)
	  {
	    strClassType = "td-listrom";
	  }else{                    
	    strClassType = "none";
	  }
	  i++;
	  
	  HashMap row = (HashMap)pageContext.getAttribute("onerow");
	if(row.get("errormessage") != null){
		strClassType = "need";
		
	}
	checkflag = (String)row.get("ck_flag");
%>
            <tr onMouseOver="this.className='tr-over'" onMouseOut="this.className='<%=strClassType%>'" class="<%=strClassType%>">
              <td><custom:write property="regionname" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="cityname" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="orgcode" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="orgname" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="statusname" name="onerow"  nbsp="true"/></td>

              <td><custom:write property="grade1" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget1" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade2" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget2" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade3" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget3" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade4" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget4" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade5" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget5" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade6" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget6" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade7" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget7" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade8" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget8" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade9" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget9" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade10" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget10" name="onerow"  nbsp="true"/></td>
              
              <td><custom:write property="grade11" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget11" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade12" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget12" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade13" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget13" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade14" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget14" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade15" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget15" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade16" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget16" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade17" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget17" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade18" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget18" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade19" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget19" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="grade20" name="onerow"  nbsp="true"/></td>
              <td><custom:write property="istarget20" name="onerow"  nbsp="true"/></td>

              <td><custom:write property="errormessage" name="onerow" nbsp="true"/></td>
            </tr>

            </logic:iterate>
</span>
			<tr>
				<td colspan="46" align="left"><%= label.getLabelName("L_TotalData") + label.getLabelName("L_Colon") %><custom:write property="count" name="count" nbsp="true"/></td>
			</tr>

            <%@ include file="/inc/SummaryAction.inc" %>
          </table>
</div>
          <table width="100%" cellspacing="0" cellpadding="0">
            <tr><td class="summary_top"></td></tr>
            <tr>
              <td class="td_center">
	      		<%if (totalsummary.size() > 0){ 
					if(checkflag == null){
				%>
				                <a onclick="page_check();"><custom:button type="1" label="L_CheckContent" imgsrc="new.gif" border="0" style="width:60"/></a>
				<%}else if(("Y").equals(checkflag)){ %>                
				                <a onclick="javascript:page_print();"><custom:button type="1" label="L_Execcd" imgsrc="new.gif" border="0" style="width:60"/></a>				           
				                <a onclick="javascript:page_confirm();"><custom:button type="1" label="L_Submit1" imgsrc="new.gif" border="0" style="width:60"/></a>
				                <a onclick="javascript:page_giveup();"><custom:button type="1" label="L_GiveUp" imgsrc="new.gif" border="0" style="width:60"/></a>
<!--				                <a onclick="javascript:page_confirm1();"><custom:button type="1" label="L_Submit1" imgsrc="new.gif" border="0" style="width:60"/></a>  				                -->
				<%}else if(("N").equals(checkflag)){ %>
				                <a onclick="javascript:page_print();"><custom:button type="1" label="L_Execcd" imgsrc="new.gif" border="0" style="width:60"/></a>				           
				                
				                <a onclick="javascript:page_giveup();"><custom:button type="1" label="L_GiveUp" imgsrc="new.gif" border="0" style="width:60"/></a>									                
				<%}}%>      
              </td>
            </tr>
          </table>
        </td>
      </tr>
    </table>
</form>
</body>
</html>